﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using Microsoft.ApplicationBlocks.Data;
using KP_CommonLibrary.KP_ObjectReferences;
using KP_CommonLibrary.KP_Business;
using KP_CommonLibrary.KP_DataAccess;

namespace KEEPER_BRR_13dotNET.BusinessLogic
{
    public class BL_KPDictionary
    {

        public static DataTable SelectTable(string tableName)
        {
            return SqlHelper.ExecuteDataTable(KP_OCnnSql.Cnn_String, CommandType.Text, "Select * from " + tableName);
        }

        public static DataTable GetGioiTinhTable()
        {
             KP_DALListBase dALBase=new KP_DALListBase("tblGioiTinh");
             return dALBase.Select();
        }

        public static DataTable GetDmTcGtTable()
        {
            return SelectTable("tblDmTcGt");
            //return dALBase.Select();
        }

        //
    }
}
